SQL #5 DECODE , CASE 사용 | 您所在的位置:网站首页 › sql decode case › SQL #5 DECODE , CASE 사용 |
1. DECODE
- switch - case와 유사하다 - code → display name을 표시할 때 - decode(colunm, case1, value1, case2, value2, ... , defalut)
SELECT first_name, job_id, department_id, decode(department_id, 10, 'Administration', 20, 'marketing', 30, 'purchasing', 90, 'Executive', 60, 'IT', 80, 'Sales', 'Not yet implemented') AS department_name FROM employees;
2. CASE .. when .. then.. end SELECT first_name || ' ' || last_name AS "full_name", job_id, salary AS before_salary, CASE WHEN job_id = 'IT_PROG' THEN salary * 1.05 WHEN job_id = 'FI_ACCOUNT' THEN salary * 1.03 WHEN job_id LIKE '%_CLERK' THEN salary * 1.02 END AS after_salary FROM employees;
|
CopyRight 2018-2019 实验室设备网 版权所有 |